﻿IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[esf_files].[P_InsertFileReferenceLevel]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [esf_files].[P_InsertFileReferenceLevel]
GO


CREATE PROCEDURE esf_files.P_InsertFileReferenceLevel
	@pFileReferenceID INT, 
	@pLevel INT,
	@pName VARCHAR (1000)
AS
	INSERT INTO esf_files.FileReferenceLevel
	(FileReferenceID, Level, Name)
	VALUES (@pFileReferenceID, @pLevel, @pName)